MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

8 rows where Artist Role = 4524

View and edit SQL

Suggested facets: Is Public Domain, Title, Object Date, Object Begin Date, Object End Date, Medium, Credit Line

Link rowid ▼ Object Number Is Highlight Is Public Domain Object ID Department Object Name Title Culture Period Dynasty Reign Portfolio Artist Role Artist Prefix Artist Display Name Artist Display Bio Artist Suffix Artist Alpha Sort Artist Nationality Artist Begin Date Artist End Date Object Date Object Begin Date Object End Date Medium Dimensions Credit Line Geography Type City State County Country Region Subregion Locale Locus Excavation River Classification Rights and Reproduction Link Resource Repository
263737 59.533.64 0 1 392683 Drawings and Prints 11 Print 731 The Departure           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|J. Hedges|Charles James Fox|Georgiana Cavendish, Duchess of Devonshire British, London 1757–1827 London|London|British, 1749–1806|British, Wimbledon, Surrey 1757–1806 Devonshire   Rowlandson, Thomas|Hedges, J.|Fox, Charles James|Cavendish, Georgiana, duchess of Devonshire 38435 British|British 9 1757 |1750 |1749 |1757 1827 |1850 |1806 |1806 April 29, 1784 1784 1784 Etching; undescribed early state 42460 Sheet: 10 1/16 × 13 13/16 in. (25.5 × 35.1 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
263739 59.533.53 0 1 392685 Drawings and Prints 11 Print 731 The Incurable           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|William Humphrey|Dr. John Monro|Charles James Fox British, London 1757–1827 London|British, 1742?–before 1814|British, Keny 1715–1791 Hadley|British, 1749–1806   Rowlandson, Thomas|Humphrey, William|Monro, John Dr.|Fox, Charles James 38437 British|British 9 1757 |1740 |1715 |1749 1827 |1814 |1791 |1806 April 4, 1784 1784 1784 Hand-colored etching 34862 Sheet: 9 9/16 × 11 7/8 in. (24.3 × 30.2 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
263740 24.63.155 0 1 392686 Drawings and Prints 11 Print 731 The Incurable           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|William Humphrey|Charles James Fox|Dr. John Monro British, London 1757–1827 London|British, 1742?–before 1814|British, 1749–1806|British, Keny 1715–1791 Hadley   Rowlandson, Thomas|Humphrey, William|Fox, Charles James|Monro, John Dr. 38438 British|British 9 1757 |1740 |1749 |1715 1827 |1814 |1806 |1791 April 4, 1784 1784 1784 Etching 26137 Sheet: 11 1/2 × 17 15/16 in. (29.2 × 45.6 cm) Plate: 9 13/16 × 12 1/16 in. (24.9 × 30.6 cm) Gift of Georgiana W. Sargent, in memory of John Osborne Sargent, 1924   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1
263741 59.533.40 0 1 392687 Drawings and Prints 11 Print 731 Billy Lackbeard and Charley Blackbeard playing at Football           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|William Humphrey|William Pitt|Charles James Fox British, London 1757–1827 London|British, 1742?–before 1814|British, 1759–1806|British, 1749–1806   Rowlandson, Thomas|Humphrey, William|Pitt, William|Fox, Charles James 38439 British|British 9 1757 |1740 |1759 |1749 1827 |1814 |1806 |1806 February 7, 1784 1784 1784 Hand-colored etching 34862 Sheet: 9 9/16 × 13 11/16 in. (24.3 × 34.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
440843 1970.541.14 0 1 735341 Drawings and Prints 11 Print 731 Reynard Put To His Shifts           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|George Humphrey|Georgiana Cavendish, Duchess of Devonshire|Charles James Fox British, London 1757–1827 London|British, 1773?–?1831|British, Wimbledon, Surrey 1757–1806 Devonshire|British, 1749–1806   Rowlandson, Thomas|Humphrey, George|Cavendish, Georgiana, duchess of Devonshire|Fox, Charles James 56078   1757 |1773 |1757 |1749 1827 |1831 |1806 |1806 April 23, 1784 1784 1784 Etching 26137 Sheet: 10 3/4 × 16 3/16 in. (27.3 × 41.1 cm) Plate: 9 5/8 × 13 11/16 in. (24.5 × 34.7 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1970                       Prints 13   Metropolitan Museum of Art, New York, NY 1
442013 59.533.430 0 1 738681 Drawings and Prints 11 Print 731 The Grand Monarck Discovered in a Pot de Chambre, or The Fugitives Turning Tail           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|Samuel William Fores|Louis XVI, King of France|Marie Antoinette, Queen of France British, London 1757–1827 London|British, 1761–1838|French, Versailles 1754–1793 Paris|French (born Austria), Vienna 1755–1792 Paris   Rowlandson, Thomas|Fores, Samuel William|Louis XVI, King of France|Marie Antoinette, Queen of France 56363   1757 |1761 |1754 |1755 1827 |1838 |1793 |1792 June 28, 1791 1791 1791 Hand-colored etching 34862 Sheet: 9 3/8 in. × 13 in. (23.8 × 33 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
445393 59.533.1315 0 0 744970 Drawings and Prints 11 Print 731 Yorkshire Hieroglyphics, Plate 2           Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|Thomas Tegg|Prince Frederick Augustus, Duke of York and Albany|Mary Anne Clarke British, London 1757–1827 London|British, 1776–1846|British, London 1763–1827 London|British, London 1776?–1852 Boulogne   Rowlandson, Thomas|Tegg, Thomas|Augustus, Frederick Duke of York and Albany|Clarke, Mary Anne 56813   1757 |1776 |1763 |1776 1827 |1846 |1827 |1852 March 11, 1809 1809 1809 Hand-colored etching 34862 Sheet: 15 9/16 × 10 1/2 in. (39.5 × 26.6 cm) Plate: 13 3/4 × 9 5/8 in. (34.9 × 24.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959                       Prints 13   Metropolitan Museum of Art, New York, NY 1
464358 59.533.1346 0 0 786814 Drawings and Prints 11 Print 731 Three Weeks After Marriage, or the Great Little Emperor Playing at Bo-Peep         'Tegg's Caricatures' 3043 Artist|Publisher|Subject|Subject 4524   Thomas Rowlandson|Thomas Tegg|Empress Marie Louise of France|Napoléon Bonaparte British, London 1757–1827 London|British, 1776–1846|1791–1847|French, Ajaccio 1769–1821 St. Helena   Rowlandson, Thomas|Tegg, Thomas|MARIE LOUISE|Bonaparte, Napoléon 59245   1757 |1776 |1791 |1769 1827 |1846 |1847 |1821 May 15, 1810 1810 1810 Hand-colored etching 34862 Sheet: 9 5/8 × 13 9/16 in. (24.5 × 34.5 cm) The Elisha Whittelsey Collection, The Elisha Whittelsey Fund, 1959   London 14                   Prints 13   Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");
Powered by Datasette · Query took 117.619ms · Data license: CC0 · Data source: metmuseum/openaccess